From 7b489ec94c3cbb0eec6dfcf819d6ea54e6bacf3d Mon Sep 17 00:00:00 2001
From: Tim Starling <tstarling@users.mediawiki.org>
Date: Sun, 3 Apr 2005 08:27:08 +0000
Subject: [PATCH] Use LinkBatch for faster link lookup

---
 includes/SpecialRecentchanges.php | 23 +++++++++++++++++++++--
 1 file changed, 21 insertions(+), 2 deletions(-)

diff --git a/includes/SpecialRecentchanges.php b/includes/SpecialRecentchanges.php
index 200d977b3a..470489ab7b 100644
--- a/includes/SpecialRecentchanges.php
+++ b/includes/SpecialRecentchanges.php
@@ -20,6 +20,7 @@ function wfSpecialRecentchanges( $par ) {
 	global $wgRequest, $wgSitename, $wgLanguageCode, $wgContLanguageCode;
 	global $wgFeedClasses, $wgUseRCPatrol;
 	global $wgRCShowWatchingUsers, $wgShowUpdatedMarker;
+	global $wgLinkCache;
 	$fname = 'wfSpecialRecentchanges';
 
 	# Get query parameters
@@ -118,19 +119,37 @@ function wfSpecialRecentchanges( $par ) {
 	  $showhide[1-$hidepatrolled], wfArrayToCGI( array( 'hidepatrolled' => 1-$hidepatrolled ), $urlparams ) );
 
 	$uid = $wgUser->getID();
-	# Patch for showing "updated since last visit" marker
+
+	// Perform query
 	$sql2 = "SELECT $recentchanges.*" . ($uid ? ",wl_user,wl_notificationtimestamp" : "") . " FROM $recentchanges " .
 	  ($uid ? "LEFT OUTER JOIN $watchlist ON wl_user={$uid} AND wl_title=rc_title AND wl_namespace=rc_namespace " : "") .
 	  "WHERE rc_timestamp > '{$cutoff}' {$hidem} " .
 	  "ORDER BY rc_timestamp DESC LIMIT {$limit}";
-
 	$res = $dbr->query( $sql2, $fname );
+
+	// Fetch results, prepare a batch link existence check query
 	$rows = array();
+	$batch = new LinkBatch;
 	while( $row = $dbr->fetchObject( $res ) ){
 		$rows[] = $row;
+		
+		// Title
+		$batch->add( $row->rc_namespace, $row->rc_title );
+
+		// User page link
+		$title = Title::makeTitleSafe( NS_USER, $row->rc_user_text );
+		$batch->addObj( $title );
+
+		// User talk
+		$title = Title::makeTitleSafe( NS_USER_TALK, $row->rc_user_text );
+		$batch->addObj( $title );
+
 	}
 	$dbr->freeResult( $res );
 
+	// Run existence checks
+	$batch->execute( $wgLinkCache );
+
 	if(isset($from)) {
 		$note = wfMsg( 'rcnotefrom', $wgLang->formatNum( $limit ),
 			$wgLang->timeanddate( $from, true ) );
-- 
2.20.1